CREATE TABLE [dbo].[Bookings]
(
[ID] [int] NOT NULL IDENTITY(1, 1),
[PaymentID] [int] NULL,
[Phone] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[MobilePhone] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[CardNo] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[TotalPaid] [money] NULL,
[CheckInDate] [datetime] NULL,
[CheckOutDate] [datetime] NULL,
[Status] [int] NULL,
[CardHolder] [nvarchar] (200) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[CardNumber] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[RoomId] [int] NULL,
[CreatedDate] [datetime] NULL,
[ModifiedDate] [datetime] NULL,
[NumberOfRooms] [int] NULL,
[CategoryRoomID] [int] NULL,
[CustomerID] [int] NULL,
[HotelID] [int] NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[Bookings] ADD CONSTRAINT [PK_PaymentDetail] PRIMARY KEY CLUSTERED  ([ID]) ON [PRIMARY]
GO
